#!/usr/bin/env python
# coding=utf-8

import xlwings as xw
import os
import pandas as pd

getpath = os.getcwd()  # 获得当前路径
app = xw.App(visible=False, add_book=False)
workbook = app.books.open('eg0504.xlsx')
worksheet = workbook.sheets
data = []
for i in worksheet:
    values = i.range('A1').expand().options(pd.DataFrame).value
    print(values)

